package com.jstide.credit.data.service.biz;

import cn.hutool.db.Entity;
import com.jstide.credit.data.service.Algorithm;
import lombok.Getter;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.sql.ResultSet;
import java.util.List;
import java.util.Optional;

public class Factor29 extends Algorithm {

    private static final Logger logger = LoggerFactory.getLogger(Factor29.class);

    @Getter
    public final  String name="29";

    //考试违纪信息
    //存在即-40，取值3年内
    //-40
    @Getter
    public  final String sql =" select  count(1) as TOTAL from ZRRKSWJXX where join_id=@joinId and  CLRQ  >  trunc(sysdate)-(INTERVAL '3' YEAR)  ";
    @Getter
    public final int defaultScore=-40;

    @Override
    public int translate(String rs) {
        return 0;
    }


    @Override
    public int translate(List<Entity> rs) { return FactorHelper.translateTotal(name,defaultScore,rs);
    }
}
